• Load Binance Data using API and Python for SQL Server Analysis

    Updated: 2023-05-30 05:00:00
    Learn how to use the Binance API and Python to load cryptocurrency data into a SQL Server database for data analysis and reporting.

  • Troubleshoot SQL Server Deadlocks in Stored Procedures

    Updated: 2023-05-30 05:00:00
    In this article, we walk through the process used to help troubleshoot SQL Server deadlocks that were occurring from stored procedures.

  • T-SQL Gap-Filling Challenge

    Updated: 2023-05-29 00:00:32
    A student of mine sent me a T-SQL challenge involving gap-filling of missing dates and balances. I found the challenge interesting and common enough and figured that my readers would probably find it interesting to work on as well. I’ll present the challenge and three possible solutions, as well as the results of a performance … The post T-SQL Gap-Filling Challenge appeared first on Simple Talk.

  • Unmasking SQL Server Dynamic Data Masking, Part 1, Intro

    Updated: 2023-05-26 19:42:33
    This is the beginning of a series on SQL Server Dynamic Data Masking. Dynamic Data Masking is a concept familiar with all developers and users of sensitive data. It is implemented in SQL Server with simplicity and elegance, requiring minimal changes to front end applications, including reporting, and almost no changes to queries. The series … The post Unmasking SQL Server Dynamic Data Masking, Part 1, Intro appeared first on Simple Talk.

  • Checking Cross-Database Referential Integrity in SQL Server - Part 1

    Updated: 2023-05-26 05:00:00
    Learn a way to build referential integrity for tables that reside in different SQL Server databases on the same server.

  • ISJSON enhancements in SQL Server for valid JSON format for a Value, Array or Object

    Updated: 2023-05-25 05:00:00
    In this article, we look at an enhancement to the ISJOSN function that allows you to validate whether the JSON format is valid for a value, array, or object.

  • Create Your First REST API using Python, Flask and HTML Code

    Updated: 2023-05-25 05:00:00
    Learn how to create a simple API to write to a SQL Server database using Python, Flask, and some HTML code.

  • Microsoft Fabric: Data Warehouse Ingestion using T-SQL and more

    Updated: 2023-05-24 10:10:22
    .In this blog I will illustrate how we can ingest data from a blob storage to a Microsoft Fabric Data Warehouse using T-SQL. Create a new workspace On the left ribbon, click Workspaces. Click the New Workspace button. Provide a name for the workspace. On advanced configuration, ensure you choose Premium by Capacity, and you … The post Microsoft Fabric: Data Warehouse Ingestion using T-SQL and more appeared first on Simple Talk.

  • Query Lock Information for SQL Server and Oracle

    Updated: 2023-05-24 05:00:00
    In this article, learn how to query lock information for both Oracle and SQL Server along with sample scripts and descriptions of each query element.

  • Data Intelligence on light speed: Microsoft Fabric

    Updated: 2023-05-24 00:00:44
    This article is based on exciting information just released at Microsoft’s Build conference on May 23, 2023. What we have today When Synapse Analytics was created, technical sessions inspired me with some comparisons and explanations, and I reproduced them in my own technical sessions and writing. Synapse was created from a request from many Microsoft … The post Data Intelligence on light speed: Microsoft Fabric appeared first on Simple Talk.

  • Self Review: Practical Graph Structures in SQL Server and Azure SQL

    Updated: 2023-05-23 20:10:43
    I just finished writing this book a few weeks ago, and as I read it, I thought “why not review my own book?” Of course, the question that first comes to mind is “are you insane?” It seems like a no-win proposition. Anything less than “best book evah” and it will seem like false modesty. … The post Self Review: Practical Graph Structures in SQL Server and Azure SQL appeared first on Simple Talk.

  • How to Visualize Timeseries Data with the Plotly Python Library

    Updated: 2023-05-23 05:00:00
    Learn how to use the Plotly library to visualize time series data in Python in this step-by-step article.

  • Fast and Efficient Way to Monitor and Solve SQL Server Performance Issues

    Updated: 2023-05-23 05:00:00
    Learn about Idera SQL Diagnostic Manager and how this performance monitoring tool can streamline and improve performance troubleshooting for your entire SQL Server environment.

  • Optimizing MySQL: Adding Data to Tables

    Updated: 2023-05-22 14:59:49
    Welcome back to the MySQL optimization series! In case you haven’t been following this series, in the past couple of articles we have discussed the basics of query optimization, and told you how to optimize SELECT queries for performance as well. In this blog, we’re further learning ways to optimize INSERT operations and look at … The post Optimizing MySQL: Adding Data to Tables appeared first on Simple Talk.

  • Multiple Relationships on the same Table in a Power BI Data Model

    Updated: 2023-05-19 05:00:00
    This article will cover how to create multiple relationships between the same tables in Power BI to build the data model you need.

  • Schedule Automated Emails using Outlook and Power Automate

    Updated: 2023-05-19 05:00:00
    Learn how to automate the sending and scheduling of emails using Power Automate.

  • Access Amazon Redshift data from SQL Server via a Linked Server

    Updated: 2023-05-19 05:00:00
    In this tip we look at how to create and use a linked server between Amazon Redshift and SQL Server.

  • Finding and fixing SQL Server database constraint issues

    Updated: 2023-05-19 05:00:00
    In this article, we look at finding and fixing constraint issues within a database using DBCC CHECKCONSTRAINTS.

  • PostgreSQL Basics: A Template for Managing Database Privileges

    Updated: 2023-05-18 14:02:38
    In the first two articles of this series about PostgreSQL privileges, we reviewed how to create roles, grant them privileges to database objects, and how object ownership is an important aspect in managing access and control within the database. When it comes to managing what roles can access or modify an existing object, ownership is … The post PostgreSQL Basics: A Template for Managing Database Privileges appeared first on Simple Talk.

  • Data Transfer from Snowflake to Azure Blob using Synapse Analytics

    Updated: 2023-05-18 05:00:00
    This article provides a simple example of how to copy data from Snowflake using the Azure Synapse Analytics pipeline.

  • Introduction to JSON, Python and REST API

    Updated: 2023-05-18 05:00:00
    Learn how to use Python to store data in a JSON format and how to deploy infrastructure in the Azure cloud using a REST API.

  • Build a Secure SQL Server REST API in Minutes

    Updated: 2023-05-18 05:00:00
    Learn how to build a secure SQL Server REST API in minutes with DreamFactory which is middleware that connects all of your applications across the enterprise in a secure manner.

  • Using Power Query in Excel for Data Extraction from a SQL Server Database

    Updated: 2023-05-17 05:00:00
    In this article, we learn how to use Power Query in Excel to transform data from SQL Server tables into useful data for Excel reporting and charts.

  • Many Uses of SQL CASE Expression in a JOIN Clause

    Updated: 2023-05-17 05:00:00
    In this article, we look at the many uses of the SQL CASE expression and whether you should ever use CASE in a JOIN.

  • Script to Decode SQL Server Locking and Blocking Wait Resources

    Updated: 2023-05-15 05:00:00
    This article provides SQL code to determine what file, table, row, or other object is locked and causing SQL Server blocking.

  • How to verify stats for the table in EBS

    Updated: 2023-05-12 09:13:00
    Oracle has provided a procedure VERIFY_STATS in the FND_STATS package to verify stats for the table in EBS This procedure reports the statistics in the data dictionary tables for the tables, indexes, and histograms. Syntax FND_STATS.VERIFY_STATS ( schemaname VARCHAR2 DEFAULT NULL, tablelist VARCHAR2 DEFAULT NULL, days_old NUMBER DEFAULT NULL, column_stat BOOLEAN DEFAULT FALSE); To verify […] The post How to verify stats for the table in EBS appeared first on Techgoeasy.

  • SQL Wildcard Examples using SQL LIKE

    Updated: 2023-05-12 05:00:00
    In this article, we look at various ways of using T-SQL to do wildcard searches for data in SQL Server tables and views.

  • How to Filter a SQL Server Audit with a Predicate

    Updated: 2023-05-12 05:00:00
    In this article, we look at how to use SSMS T-SQL to enter a predicate filter on a SQL Server Audit definition to allow filtering an audit.

  • STATISTICS_LEVEL in Oracle

    Updated: 2023-05-11 08:07:00
    The STATISTICS_LEVEL parameter was introduced in Oracle version 9 (9.2) to control allmajor statistics collections or advisories in the database. The level of the setting affects thea number of statistics and advisories that are enabled. These listed below are for 10g and above How to set this parameter This is a dynamic parameter and does […] The post STATISTICS_LEVEL in Oracle appeared first on Techgoeasy.

  • Change Secondary Region of a Failover Group for Azure SQL Database

    Updated: 2023-05-11 05:00:00
    This article explains the process to change the secondary region for an Azure Failover Group for Azure SQL Databases.

  • Move SQL Profiles from One Database to Another 

    Updated: 2023-05-10 08:51:00
    In this post, we will check out how to move SQL Profiles from One Database to Another  How to move the sql profiles Suppose you have created a sql profile in System A and Now you want to transfer that sql profile to System B. Step 1On System A: Creating a staging table to store […] The post Move SQL Profiles from One Database to Another  appeared first on Techgoeasy.

  • SQL Server WAIT_AT_LOW_PRIORITY option to create indexes

    Updated: 2023-05-10 05:00:00
    Learn about a new feature in SQL Server 2022 - Wait at Low Priority - that allows index creation to wait for resources to become available before executing.

  • SQL SUBSTRING Function Code Examples

    Updated: 2023-05-10 05:00:00
    Learn different ways to use the SQL SUBSTRING function along with several different code examples of how this can be used.

  • Always Encrypted: Enhancements in SQL Server

    Updated: 2023-05-09 05:00:00
    In this article, learn how to use Always Encrypted to encrypt SQL Server data along with some of the changes that have been made since its first release in 2016.

  • Chi-Square Test for Homogeneity in SQL Server

    Updated: 2023-05-09 05:00:00
    This article provides a use case for professionals preparing data for and implementing custom homogeneity tests for data stored in SQL Server.

  • How to compare statistics using history for a table in Oracle

    Updated: 2023-05-08 08:23:12
    We often experience performance issues because of the inaccurate statistics for the objects involved and we want to know what the difference is between the statistics of good time and bad time With 12c, we can use the DBMS_STATS procedure to find the difference between the statistics How to compare statistics using history for a […] The post How to compare statistics using history for a table in Oracle appeared first on Techgoeasy.

  • How to Install cosmicworks a Sample Database in Azure Cosmos DB

    Updated: 2023-05-08 05:00:00
    In this article, we walk through a few different options to set up the sample Cosmos DB database cosmicworks for testing and other needs.

  • How to create environment variables in Windows

    Updated: 2023-05-06 09:21:00
    Many times Oracle DBA while working on Windows might need to create environment variables like ORACLE_HOME, ORACLE_SID, and TNS_ADMIN. Here in this post, we will check How to create environment variables in Windows How to create environment variables in Windows Step 1: Log in to the server with a user who has an administrator privileged […] The post How to create environment variables in Windows appeared first on Techgoeasy.

  • Calculate Non Linear Relationships such as Exponential, Logarithmic, Quadratic and Cubic using Python

    Updated: 2023-05-05 05:00:00
    In this article, we look at examples of non-linear relationships such as exponential, logarithmic, quadratic, and cubic using Python.

  • A Proposed Data Warehouse Architecture for Small and Medium Businesses

    Updated: 2023-05-04 05:00:00
    Learn about the process and principal components of building a data warehouse and learn about the five predominant architectures Independent Data Marts, Data Mart Buses, Hub-and-Spoke, Centralized Data Warehouses, and Federated.

  • Get Database Insights Across Your Environment

    Updated: 2023-05-03 05:00:00
    Learn how to improve your database efficiency with SolarWinds Database Insights, which combines two enterprise-ready products: Database Performance Analyzer (DPA) and SQL Sentry.

Current Feed Items | Previous Months Items

Apr 2023 | Mar 2023 | Feb 2023 | Jan 2023 | Dec 2022 | Nov 2022